﻿--获取岗位薪资
CREATE PROCEDURE [dbo].[proc_Post_GetList]
(
	@startIndex int,
	@endIndex int,
	@postname nvarchar(50)
)
as

set nocount on

	;WITH list As(Select ROW_NUMBER() OVER (ORDER BY Id  Asc)AS Row,
		Id,
		PostName,
		PostWage,
		JxWage,
		ManQin,
		Memo
--		,(Select Count(Id) From Post Where postname like '%'+@postname+'%' And Id > 3336) AS coun
		
		From 
			Post
		WHERE
					postname like '%'+@postname+'%'
				And Id > 3336
	)
	Select *,(SELECT COUNT(0) FROM list) AS coun From list Where Row between @StartIndex and @EndIndex 
set nocount off
RETURN
